Foreign Keys

db_globoxylo

Foreign Keys

Schema	Table	Foreign Key	Columns	FK Table	FK Columns	Delete Action	Update Action	Check Time	Description
application	t_demande_rgpd	c_fk_rgpd_typrgpd	rgpd_typrgpd_id	application.tr_type_rgpd_typrgpd	typrgpd_id	No Action	No Action	Immediate
application	t_demande_rgpd	c_fk_usr_rgpd	rgpd_usr_id	application.t_utilisateur_usr	usr_id	No Action	No Action	Immediate
application	t_utilisateur_usr	c_fk_usr_org	usr_org_id	application.t_organisation_org	org_id	No Action	No Action	Immediate	Rattachement d'une organisation à un utilisateur.
application	t_utilisateur_usr	c_fk_usr_serv	usr_serv_id	application.t_service_serv	serv_id	No Action	No Action	Immediate	Rattachement d'un service à un utilisateur.
application	tj_apermission_rol_perm_aperm	c_fk_perm_aperm	aperm_perm_id	application.tr_permission_perm	perm_id	Cascade	No Action	Immediate	Association d'une permission à un rôle.
application	tj_apermission_rol_perm_aperm	c_fk_rol_aperm	aperm_rol_id	application.tr_role_rol	rol_id	Cascade	No Action	Immediate	Association d'un rôle à une permission.
application	tj_arole_usr_rol_arol	c_fk_rol_arol	arol_rol_id	application.tr_role_rol	rol_id	Cascade	No Action	Immediate	Association d'un rôle à un compte utilisateur.
application	tj_arole_usr_rol_arol	c_fk_usr_arol	arol_usr_id	application.t_utilisateur_usr	usr_id	Cascade	No Action	Immediate	Association d'un compte utilisateur à un rôle.
application	tj_role_parent_rol_rol_rolp	c_fk_role_enfant_rolp	rolp_role_enfant_id	application.tr_role_rol	rol_id	Cascade	No Action	Immediate	Association d'un rôle enfant.
application	tj_role_parent_rol_rol_rolp	c_fk_role_parent_rolp	rolp_role_parent_id	application.tr_role_rol	rol_id	Cascade	No Action	Immediate	Association d'un rôle parent.
public	t_grouping_grp	c_fk_fil_grp	grp_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	a grouping can be attached to O or 1 file
public	t_grouping_grp	c_fk_prot_grp	grp_prot_id	public.tr_protocol_prot	prot_id	No Action	No Action	Immediate	a grouping can be attached to O or 1 protocol
public	t_grouping_grp	c_fk_std_grp	grp_std_id	public.tr_standard_std	std_id	No Action	No Action	Immediate	a grouping can be attached to O or 1 standard
public	t_grouping_grp	c_fk_tym_grp	grp_tym_id	public.tr_type_measure_tym	tym_id	No Action	No Action	Immediate	a grouping can be attached to O or 1 type of measure
public	t_grouping_grp	c_fk_uni_grp	grp_uni_id	public.tr_unit_uni	uni_id	No Action	No Action	Immediate	a grouping can be attached to O or 1 unit
public	t_measure_msam	c_fk_fil_msam	msam_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	a measure can be attached to O or 1 file
public	t_measure_msam	c_fk_prot_msam	msam_prot_id	public.tr_protocol_prot	prot_id	No Action	No Action	Immediate	a measure can be attached to O or 1 protocol
public	t_measure_msam	c_fk_sam_msam	msam_sam_id	public.t_sample_sam	sam_id	No Action	No Action	Immediate	a measure must be attached to one and only one object
public	t_measure_msam	c_fk_std_msam	msam_std_id	public.tr_standard_std	std_id	No Action	No Action	Immediate	a measure can be attached to O or 1 standard
public	t_measure_msam	c_fk_tym_msam	msam_tym_id	public.tr_type_measure_tym	tym_id	No Action	No Action	Immediate	a measure can be attached to O or 1 type of measure
public	t_measure_msam	c_fk_uni_msam	msam_uni_id	public.tr_unit_uni	uni_id	No Action	No Action	Immediate	a measure can be attached to O or 1 unit
public	t_measure_msam	c_fk_var_msam	msam_var_id	public.tr_variable_var	var_id	No Action	No Action	Immediate	a measure must be attached to one and only one variable
public	t_measure_mtre	c_fk_fil_mtre	mtre_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	a measure can be attached to O or 1 file
public	t_measure_mtre	c_fk_prot_mtre	mtre_prot_id	public.tr_protocol_prot	prot_id	No Action	No Action	Immediate	a measure can be attached to O or 1 protocol
public	t_measure_mtre	c_fk_std_mtre	mtre_std_id	public.tr_standard_std	std_id	No Action	No Action	Immediate	a measure can be attached to O or 1 standard
public	t_measure_mtre	c_fk_tre_mtre	mtre_tre_id	public.t_tree_tre	tre_id	No Action	No Action	Immediate	a measure must be attached to one and only one object
public	t_measure_mtre	c_fk_tym_mtre	mtre_tym_id	public.tr_type_measure_tym	tym_id	No Action	No Action	Immediate	a measure can be attached to O or 1 type of measure
public	t_measure_mtre	c_fk_uni_mtre	mtre_uni_id	public.tr_unit_uni	uni_id	No Action	No Action	Immediate	a measure can be attached to O or 1 unit
public	t_measure_mtre	c_fk_var_mtre	mtre_var_id	public.tr_variable_var	var_id	No Action	No Action	Immediate	a measure must be attached to one and only one variable
public	t_measure_mzon	c_fk_fil_mzon	mzon_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	a measurement can be attached to O or 1 file
public	t_measure_mzon	c_fk_prot_mzon	mzon_prot_id	public.tr_protocol_prot	prot_id	No Action	No Action	Immediate	a measurement can be attached to O or 1 protocol
public	t_measure_mzon	c_fk_std_mzon	mzon_std_id	public.tr_standard_std	std_id	No Action	No Action	Immediate	a measure can be attached to O or 1 standard
public	t_measure_mzon	c_fk_tym_mzon	mzon_tym_id	public.tr_type_measure_tym	tym_id	No Action	No Action	Immediate	a measure can be attached to O or 1 type of measure
public	t_measure_mzon	c_fk_uni_mzon	mzon_uni_id	public.tr_unit_uni	uni_id	No Action	No Action	Immediate	a measure can be attached to 0 or 1 unit
public	t_measure_mzon	c_fk_var_mzon	mzon_var_id	public.tr_variable_var	var_id	No Action	No Action	Immediate	a measure must be linked to one and only one variable
public	t_measure_mzon	c_fk_zon_mzon	mzon_zon_id	public.tr_study_zone_zon	zon_id	No Action	No Action	Immediate	a measure must be attached to one and only one object
public	t_sample_sam	c_fk_tre_ech	sam_tre_id	public.t_tree_tre	tre_id	No Action	No Action	Immediate
public	t_tree_tre	c_fk_tax_tre	tre_tax_id	public.tr_taxon_tax	tax_id	No Action	No Action	Immediate	A tree is attached to one and only one taxon
public	t_tree_tre	c_fk_zon_tre	tre_zon_id	public.tr_study_zone_zon	zon_id	No Action	No Action	Immediate	A tree is attached to one and only one study area
public	tj_classifyvar_cvar	c_fk_rank_cvar	cvar_rank_id	public.tr_ranking_rank	rank_id	No Action	No Action	Immediate	The cvar_rank_id field necessarily corresponds to an existing ranking
public	tj_classifyvar_cvar	c_fk_var_cvar	cvar_var_id	public.tr_variable_var	var_id	No Action	No Action	Immediate	The cvar_var_id field must correspond to an existing variable
public	tj_grp_msam_gms	c_fk_grp_gms	gms_grp_id	public.t_grouping_grp	grp_id	No Action	No Action	Immediate	The gms_grp_id field necessarily corresponds to an existing grouping
public	tj_grp_msam_gms	c_fk_msam_gms	gms_msam_id	public.t_measure_msam	msam_id	No Action	No Action	Immediate	The gms_msam_id field necessarily corresponds to an existing measure
public	tj_grp_mtre_gmt	c_fk_grp_gmt	gmt_grp_id	public.t_grouping_grp	grp_id	No Action	No Action	Immediate	The gmt_grp_id field necessarily corresponds to an existing grouping
public	tj_grp_mtre_gmt	c_fk_mtre_gmt	gmt_mtre_id	public.t_measure_mtre	mtre_id	No Action	No Action	Immediate	The gmt_mtre_id field necessarily corresponds to an existing measure
public	tj_grp_mzon_gmz	c_fk_grp_gmz	gmz_grp_id	public.t_grouping_grp	grp_id	No Action	No Action	Immediate	The gmz_grp_id field necessarily corresponds to an existing grouping
public	tj_grp_mzon_gmz	c_fk_mzon_gmz	gmz_mzon_id	public.t_measure_mzon	mzon_id	No Action	No Action	Immediate	The gmz_mzon_id field necessarily corresponds to an existing measurement
public	tj_msam_msam_tsam	c_fk_meta_msam_tsam	tsam_meta_msam_id	public.t_measure_msam	msam_id	No Action	No Action	Immediate	The tsam_meta_msam_id field necessarily corresponds to an existing measure
public	tj_msam_msam_tsam	c_fk_ref_msam_tsam	tsam_ref_msam_id	public.t_measure_msam	msam_id	No Action	No Action	Immediate	The tsam_ref_msam_id field necessarily corresponds to an existing measure
public	tj_mtre_mtre_ttre	c_fk_meta_mtre_ttre	ttre_meta_mtre_id	public.t_measure_mtre	mtre_id	No Action	No Action	Immediate	The ttre_meta_mtre_id field necessarily corresponds to an existing measure
public	tj_mtre_mtre_ttre	c_fk_ref_mtre_ttre	ttre_ref_mtre_id	public.t_measure_mtre	mtre_id	No Action	No Action	Immediate	The ttre_ref_mtre_id field necessarily corresponds to an existing measure
public	tj_mzon_mzon_tzon	c_fk_meta_mzon_tzon	tzon_meta_mzon_id	public.t_measure_mzon	mzon_id	No Action	No Action	Immediate	The tzon_meta_mzon_id field necessarily corresponds to an existing measurement
public	tj_mzon_mzon_tzon	c_fk_ref_mzon_tzon	tzon_ref_mzon_id	public.t_measure_mzon	mzon_id	No Action	No Action	Immediate	The tzon_ref_mzon_id field necessarily corresponds to an existing measurement
public	tj_rol_ope_grp_rog	c_fk_grp_rog	rog_grp_id	public.t_grouping_grp	grp_id	No Action	No Action	Immediate	The rog_grp_id field necessarily corresponds to an existing grouping
public	tj_rol_ope_grp_rog	c_fk_ope_rog	rog_ope_id	public.tr_operator_ope	ope_id	No Action	No Action	Immediate	The rog_ope_id field must correspond to an existing operator
public	tj_rol_ope_grp_rog	c_fk_rol_rog	rog_rol_id	public.tr_role_rol	rol_id	No Action	No Action	Immediate	The rog_rol_id field must correspond to an existing role
public	tj_rol_ope_msam_ros	c_fk_msam_ros	ros_msam_id	public.t_measure_msam	msam_id	No Action	No Action	Immediate	The ros_msam_id field necessarily corresponds to an existing measure
public	tj_rol_ope_msam_ros	c_fk_ope_ros	ros_ope_id	public.tr_operator_ope	ope_id	No Action	No Action	Immediate	The ros_ope_id field necessarily corresponds to an existing operator
public	tj_rol_ope_msam_ros	c_fk_rol_ros	ros_rol_id	public.tr_role_rol	rol_id	No Action	No Action	Immediate	The ros_rol_id field necessarily corresponds to an existing role
public	tj_rol_ope_mtre_rot	c_fk_mtre_rot	rot_mtre_id	public.t_measure_mtre	mtre_id	No Action	No Action	Immediate	The rot_mtre_id field necessarily corresponds to an existing measure
public	tj_rol_ope_mtre_rot	c_fk_ope_rot	rot_ope_id	public.tr_operator_ope	ope_id	No Action	No Action	Immediate	The rot_ope_id field necessarily corresponds to an existing operator
public	tj_rol_ope_mtre_rot	c_fk_rol_rot	rot_rol_id	public.tr_role_rol	rol_id	No Action	No Action	Immediate	The rot_rol_id field necessarily corresponds to an existing role
public	tj_rol_ope_mzon_roz	c_fk_mzon_roz	roz_mzon_id	public.t_measure_mzon	mzon_id	No Action	No Action	Immediate	The roz_mzon_id field necessarily corresponds to an existing measurement
public	tj_rol_ope_mzon_roz	c_fk_ope_roz	roz_ope_id	public.tr_operator_ope	ope_id	No Action	No Action	Immediate	The roz_ope_id field necessarily corresponds to an existing operator
public	tj_rol_ope_mzon_roz	c_fk_rol_roz	roz_rol_id	public.tr_role_rol	rol_id	No Action	No Action	Immediate	The roz_rol_id field must correspond to an existing role
public	tr_study_zone_zon	c_fk_typz_zon	zon_typz_id	public.tr_type_study_zone_typz	typz_id	No Action	No Action	Immediate	a study zone must be attached to 1 and 1 type of study zone
public	tr_taxon_tax	c_fk_ref_tax	tax_ref_id	public.tr_taxonomic_referential_ref	ref_id	No Action	No Action	Immediate	A taxon is linked to 1 and 1 single referential
topology	layer	layer_topology_id_fkey	topology_id	topology.topology	id	No Action	No Action	Immediate

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)